Manager | Not Applicable | Delhi | Regulatory & Financial Risk

Proficient with data warehouse/ data lake development methodologies and the ability to apply best practices in building scalable and maintainable data warehouses/data lakeStrong SQL skills including Data Definition Language (DDL), Data Manipulation Language (DML), views, functions and stored proceduresProficiency in ETL tools like Azure Data Factory, Azure Synapse, or Microsoft SSIS (SQL Server Integration Services) to extract data from various sources and APIs, transform it to fit the target schema, and load it into the data warehouse/data lakeAbility to design and implement data warehouse data models, including star schema, snowflake schema, and dimension hierarchies for optimized data retrieval and analysisExpert in data integration techniques and data quality processes to ensure data accuracy, consistency, and reliability in the data warehouseExpert on data warehouse architecture principles, such as data staging areas, data marts, data lakes, and the overall data flowProficient in Python or Scala scripting for automating ETL processes and data manipulationProficient with Git and DevOps deployment technologiesUnderstanding of data security principles and compliance regulations to protect sensitive information in the data warehouses/data lakeSkills in optimizing data warehouse/data lake performance, including query optimization, index creation, and partitioning